package com.example.mapper;


import com.example.pojo.bo.HomeCompanyBO;
import com.example.pojo.entity.JobRecruiter;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 *  用以获取招聘者用户信息
 * @author GXF
 * @Date 2023/10/3 15:59
 */
public interface JobRecruiterMapper {
    @Select("select * from job_recruiter where jr_account=#{account} and jr_cipher=#{cipher}")
    JobRecruiter findJobRecruiterByAccountAndCipher(@Param("account") String account , @Param("cipher") String cipher);

    @Select("select * from job_recruiter where id=#{value}")
    JobRecruiter fingJobRecruiterById(Integer id);

    @Select("select company_name from job_recruiter where id = #{value}")
    String findCompanyName(Integer id);
    @Select("select id,company_name,company_type,employees_quantity,jr_avatar,run_state from job_recruiter")
    List<HomeCompanyBO> findCompanyAll();



}
